inherited Frmtd_product_List: TFrmtd_product_List
  Left = 384
  Top = 97
  Caption = #36135#21697#36164#26009
  ClientHeight = 448
  ClientWidth = 827
  ExplicitWidth = 845
  ExplicitHeight = 519
  PixelsPerInch = 119
  TextHeight = 12
  inherited Panel1: TPanel
    Width = 827
    ExplicitWidth = 827
    inherited img3: TImage
      Left = 504
      ExplicitLeft = 504
    end
    inherited edtFilter: TcxTextEdit
      ExplicitHeight = 20
    end
  end
  inherited pnlMain: TPanel
    Left = 193
    Width = 634
    Height = 358
    ParentColor = True
    ExplicitLeft = 193
    ExplicitWidth = 634
    ExplicitHeight = 358
    inherited MainDataGrid: TcxGrid
      Width = 634
      Height = 358
      ExplicitWidth = 634
      ExplicitHeight = 358
      object MainDataGridDBBandedTableView: TcxGridDBBandedTableView [1]
        OnDblClick = MainDataGridDBBandedTableViewDblClick
        OnKeyDown = MainDataGridDBBandedTableViewKeyDown
        OnKeyUp = MainDataGridDBBandedTableViewKeyUp
        Navigator.Buttons.CustomButtons = <>
        OnCustomDrawCell = MainDataGridDBBandedTableViewCustomDrawCell
        DataController.DataModeController.GridMode = True
        DataController.DataSource = MainDataSource
        DataController.Filter.Active = True
        DataController.Summary.DefaultGroupSummaryItems = <>
        DataController.Summary.FooterSummaryItems = <
          item
            Kind = skCount
            FieldName = 'code'
            Column = code
          end>
        DataController.Summary.SummaryGroups = <>
        OptionsCustomize.ColumnHiding = True
        OptionsCustomize.ColumnsQuickCustomization = True
        OptionsData.Editing = False
        OptionsData.Inserting = False
        OptionsSelection.MultiSelect = True
        OptionsSelection.CellMultiSelect = True
        OptionsSelection.InvertSelect = False
        OptionsView.Footer = True
        OptionsView.GroupByBox = False
        OptionsView.Indicator = True
        OptionsView.IndicatorWidth = 32
        Styles.Background = MainDM.bslBackGroup
        Styles.ContentEven = MainDM.bsEven
        Styles.ContentOdd = MainDM.bsOdd
        Styles.Footer = MainDM.bsTitle
        Styles.Header = MainDM.bsTitle
        Styles.Selection = MainDM.bsSelect
        Styles.BandBackground = MainDM.bsTitle
        Styles.BandHeader = MainDM.bsTitle
        OnCustomDrawIndicatorCell = MainDataGridDBBandedTableViewCustomDrawIndicatorCell
        Bands = <
          item
          end
          item
            Caption = #22522#26412#21333#20301
          end
          item
          end>
        object code: TcxGridDBBandedColumn
          Caption = #36135#21697#32534#30721
          DataBinding.FieldName = 'code'
          Width = 80
          Position.BandIndex = 0
          Position.ColIndex = 0
          Position.RowIndex = 0
        end
        object name: TcxGridDBBandedColumn
          Caption = #36135#21697#21517#31216
          DataBinding.FieldName = 'name'
          Width = 120
          Position.BandIndex = 0
          Position.ColIndex = 1
          Position.RowIndex = 0
        end
        object spec: TcxGridDBBandedColumn
          Caption = #35268#26684
          DataBinding.FieldName = 'spec'
          Width = 100
          Position.BandIndex = 0
          Position.ColIndex = 2
          Position.RowIndex = 0
        end
        object kindname: TcxGridDBBandedColumn
          Caption = #36135#21697#23646#24615
          DataBinding.FieldName = 'kindname'
          Width = 60
          Position.BandIndex = 0
          Position.ColIndex = 3
          Position.RowIndex = 0
        end
        object depotname: TcxGridDBBandedColumn
          DataBinding.FieldName = 'depotname'
          Width = 60
          Position.BandIndex = 0
          Position.ColIndex = 8
          Position.RowIndex = 0
        end
        object quantity: TcxGridDBBandedColumn
          Caption = #24080#38754#24211#23384
          DataBinding.FieldName = 'quantity'
          Width = 80
          Position.BandIndex = 0
          Position.ColIndex = 4
          Position.RowIndex = 0
        end
        object factqty: TcxGridDBBandedColumn
          Caption = #23454#38469#24211#23384
          DataBinding.FieldName = 'factqty'
          DateTimeGrouping = dtgRelativeToToday
          Width = 80
          Position.BandIndex = 0
          Position.ColIndex = 5
          Position.RowIndex = 0
        end
        object batch: TcxGridDBBandedColumn
          Caption = #25209#21495#31649#29702
          DataBinding.FieldName = 'batch'
          PropertiesClassName = 'TcxCheckBoxProperties'
          Width = 35
          Position.BandIndex = 0
          Position.ColIndex = 6
          Position.RowIndex = 0
        end
        object producttrademarkname: TcxGridDBBandedColumn
          DataBinding.FieldName = 'producttrademarkname'
          Width = 60
          Position.BandIndex = 0
          Position.ColIndex = 9
          Position.RowIndex = 0
        end
        object caclcostname: TcxGridDBBandedColumn
          Caption = #25104#26412#26680#31639
          DataBinding.FieldName = 'calccostname'
          Width = 110
          Position.BandIndex = 0
          Position.ColIndex = 7
          Position.RowIndex = 0
        end
        object unitid: TcxGridDBBandedColumn
          Caption = #21333#20301#21517#31216
          DataBinding.FieldName = 'unitname'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 0
          Position.RowIndex = 0
        end
        object purreprice: TcxGridDBBandedColumn
          Caption = #21442#32771#36827#20215
          DataBinding.FieldName = 'purreprice'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 1
          Position.RowIndex = 0
        end
        object salereprice: TcxGridDBBandedColumn
          Caption = #21442#32771#21806#20215
          DataBinding.FieldName = 'salereprice'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 2
          Position.RowIndex = 0
        end
        object barcode: TcxGridDBBandedColumn
          Caption = #26465#30721
          DataBinding.FieldName = 'barcode'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 3
          Position.RowIndex = 0
        end
        object weightcode: TcxGridDBBandedColumn
          Caption = #31216#37325#30721
          DataBinding.FieldName = 'wtcode'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 4
          Position.RowIndex = 0
        end
        object purtopprice: TcxGridDBBandedColumn
          Caption = #26368#39640#36827#20215
          DataBinding.FieldName = 'purtopprice'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 5
          Position.RowIndex = 0
        end
        object salelowprice: TcxGridDBBandedColumn
          Caption = #26368#20302#21806#20215
          DataBinding.FieldName = 'salelowprice'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 6
          Position.RowIndex = 0
        end
        object vipprice: TcxGridDBBandedColumn
          Caption = #20250#21592#20215
          DataBinding.FieldName = 'vipprice'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 7
          Position.RowIndex = 0
        end
        object price1: TcxGridDBBandedColumn
          Caption = #19968#32423#25209#21457#20215
          DataBinding.FieldName = 'price1'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 8
          Position.RowIndex = 0
        end
        object price2: TcxGridDBBandedColumn
          Caption = #20108#32423#25209#21457#20215
          DataBinding.FieldName = 'price2'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 9
          Position.RowIndex = 0
        end
        object price3: TcxGridDBBandedColumn
          Caption = #19977#32423#25209#21457#20215
          DataBinding.FieldName = 'price3'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 10
          Position.RowIndex = 0
        end
        object price4: TcxGridDBBandedColumn
          Caption = #22235#32423#25209#21457#20215
          DataBinding.FieldName = 'price4'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 11
          Position.RowIndex = 0
        end
        object price5: TcxGridDBBandedColumn
          Caption = #20116#32423#25209#21457#20215
          DataBinding.FieldName = 'price5'
          Width = 60
          Position.BandIndex = 1
          Position.ColIndex = 12
          Position.RowIndex = 0
        end
        object custom1: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom1'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 4
          Position.RowIndex = 0
        end
        object custom2: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom2'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 5
          Position.RowIndex = 0
        end
        object custom3: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom3'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 6
          Position.RowIndex = 0
        end
        object custom4: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom4'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 7
          Position.RowIndex = 0
        end
        object custom5: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom5'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 8
          Position.RowIndex = 0
        end
        object custom6: TcxGridDBBandedColumn
          Caption = #33258#23450#20041#23383#27573'6'
          DataBinding.FieldName = 'custom6'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 0
          Position.RowIndex = 0
        end
        object custom7: TcxGridDBBandedColumn
          Caption = #33258#23450#20041#23383#27573'7'
          DataBinding.FieldName = 'custom7'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 1
          Position.RowIndex = 0
        end
        object custom8: TcxGridDBBandedColumn
          Caption = #33258#23383#20041#23383#27573'8'
          DataBinding.FieldName = 'custom8'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 2
          Position.RowIndex = 0
        end
        object custom9: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom9'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 9
          Position.RowIndex = 0
        end
        object custom10: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom10'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 10
          Position.RowIndex = 0
        end
        object custom11: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom11'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 11
          Position.RowIndex = 0
        end
        object custom12: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom12'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 12
          Position.RowIndex = 0
        end
        object custom13: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom13'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 13
          Position.RowIndex = 0
        end
        object custom14: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom14'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 14
          Position.RowIndex = 0
        end
        object custom15: TcxGridDBBandedColumn
          DataBinding.FieldName = 'custom15'
          Visible = False
          Width = 80
          Position.BandIndex = 2
          Position.ColIndex = 15
          Position.RowIndex = 0
        end
        object pause: TcxGridDBBandedColumn
          Caption = #20572#29992#26631#24535
          DataBinding.FieldName = 'pause'
          PropertiesClassName = 'TcxCheckBoxProperties'
          Width = 30
          Position.BandIndex = 2
          Position.ColIndex = 3
          Position.RowIndex = 0
        end
      end
      inherited MainDataGridLevel1: TcxGridLevel
        GridView = MainDataGridDBBandedTableView
      end
    end
  end
  object RzPanel1: TRzPanel [4]
    Left = 0
    Top = 45
    Width = 185
    Height = 358
    Align = alLeft
    BorderOuter = fsNone
    Ctl3D = True
    ParentCtl3D = False
    TabOrder = 3
    object CoolBar1: TCoolBar
      Left = 0
      Top = 0
      Width = 185
      Height = 25
      Bands = <
        item
          Control = CbbOption
          ImageIndex = -1
          MinHeight = 21
          Width = 179
        end>
      object CbbOption: TcxComboBox
        Left = 11
        Top = 0
        Properties.ImmediatePost = True
        Properties.OnValidate = CbbOptionPropertiesValidate
        TabOrder = 0
        Width = 170
      end
    end
    object treType: TcxTreeView
      Left = 0
      Top = 25
      Width = 185
      Height = 148
      Align = alClient
      TabOrder = 1
      OnClick = treTypeClick
      Images = MainDM.imgList
    end
    object pnlPic: TPanel
      Left = 0
      Top = 173
      Width = 185
      Height = 185
      Align = alBottom
      BevelOuter = bvNone
      TabOrder = 2
      Visible = False
    end
  end
  object cxSplitter1: TcxSplitter [5]
    Left = 185
    Top = 45
    Width = 8
    Height = 358
    Cursor = crHSplit
    HotZoneClassName = 'TcxSimpleStyle'
    Control = RzPanel1
  end
  inherited pnlBottom: TPanel
    Top = 403
    Width = 827
    ExplicitTop = 403
    ExplicitWidth = 827
    inherited chkGroupSort: TcxCheckBox
      Left = 193
      TabOrder = 2
      ExplicitLeft = 193
      ExplicitWidth = 69
      ExplicitHeight = 20
    end
    inherited chkHandGroup: TcxCheckBox
      Left = 262
      TabOrder = 7
      ExplicitLeft = 262
      ExplicitWidth = 69
      ExplicitHeight = 20
    end
    inherited lblGroupSort: TcxLabel
      Left = 338
      Top = 5
      ExplicitLeft = 338
      ExplicitTop = 5
    end
    inherited edtPause: TcxComboBox
      Left = 735
      ExplicitLeft = 735
      ExplicitHeight = 20
    end
    inherited chkGridFilter: TcxCheckBox
      Left = 598
      ExplicitLeft = 598
      ExplicitWidth = 69
      ExplicitHeight = 20
    end
    object chkShowPic: TcxCheckBox
      Left = 664
      Top = 12
      Anchors = [akRight, akBottom]
      Caption = #26174#31034#22270#29255
      Properties.ImmediatePost = True
      TabOrder = 0
      Transparent = True
      OnClick = chkShowPicClick
    end
  end
  inherited ImageList1: TImageList
    Left = 19
    Top = 283
  end
  inherited MainMenu1: TMainMenu
    Top = 172
  end
  inherited PopupMenu1: TPopupMenu
    Top = 226
  end
  inherited qyTmpDataSet: TUniQuery
    Top = 130
  end
  inherited MainDataSetU: TUniQuery
    SQLInsert.Strings = (
      'Insert into TD_PRODUCT(p_id,'
      'code,'
      'name,'
      'abname,'
      'spec,'
      'producttypeid,'
      'producttrademarkid,'
      'depotkindid,'
      'depotid,'
      'layid,'
      'kind,'
      'cprice,'
      'quantity,'
      'factqty,'
      'assqty,'
      'factassqty,'
      'calccost,'
      'validdates,'
      'assembly,'
      'custom1,'
      'custom2,'
      'custom3,'
      'custom4,'
      'custom5,'
      'custom6,'
      'custom7,'
      'custom8,'
      'custom9,'
      'custom10,'
      'posyear,'
      'posmonth,'
      'tag,'
      'puraddqty,'
      'mrp,'
      'advancedays,'
      'traderid,'
      'minpurqty,'
      'pause,'
      'batch,'
      'custom11,'
      'custom12,'
      'custom13,'
      'custom14,'
      'custom15,'
      'drp,'
      'empid,'
      'workshopid,'
      'warndays,'
      'share,'
      'imei,'
      'length,'
      'width,'
      'height,'
      'specificweight,'
      'scorerate,'
      'scoreexch,'
      'sharedraw,'
      'mindrawqty'
      ')'
      'Values'
      '(:p_id,'
      ':code,'
      ':name,'
      ':abname,'
      ':spec,'
      ':producttypeid,'
      ':producttrademarkid,'
      ':depotkindid,'
      ':depotid,'
      ':layid,'
      ':kind,'
      ':cprice,'
      ':quantity,'
      ':factqty,'
      ':assqty,'
      ':factassqty,'
      ':calccost,'
      ':validdates,'
      ':assembly,'
      ':custom1,'
      ':custom2,'
      ':custom3,'
      ':custom4,'
      ':custom5,'
      ':custom6,'
      ':custom7,'
      ':custom8,'
      ':custom9,'
      ':custom10,'
      ':posyear,'
      ':posmonth,'
      ':tag,'
      ':puraddqty,'
      ':mrp,'
      ':advancedays,'
      ':traderid,'
      ':minpurqty,'
      ':pause,'
      ':batch,'
      ':custom11,'
      ':custom12,'
      ':custom13,'
      ':custom14,'
      ':custom15,'
      ':drp,'
      ':empid,'
      ':workshopid,'
      ':warndays,'
      ':share,'
      ':imei,'
      ':length,'
      ':width,'
      ':height,'
      ':specificweight,'
      ':scorerate,'
      ':scoreexch,'
      ':sharedraw,'
      ':mindrawqty'
      ')')
    SQLDelete.Strings = (
      'Delete from TD_PRODUCT where p_id=:OLD_p_id')
    SQLUpdate.Strings = (
      'Update TD_PRODUCT set '
      'p_id=:p_id,'
      'code=:code,'
      'name=:name,'
      'abname=:abname,'
      'spec=:spec,'
      'producttypeid=:producttypeid,'
      'producttrademarkid=:producttrademarkid,'
      'depotkindid=:depotkindid,'
      'depotid=:depotid,'
      'layid=:layid,'
      'kind=:kind,'
      'cprice=:cprice,'
      'quantity=:quantity,'
      'factqty=:factqty,'
      'assqty=:assqty,'
      'factassqty=:factassqty,'
      'calccost=:calccost,'
      'validdates=:validdates,'
      'assembly=:assembly,'
      'custom1=:custom1,'
      'custom2=:custom2,'
      'custom3=:custom3,'
      'custom4=:custom4,'
      'custom5=:custom5,'
      'custom6=:custom6,'
      'custom7=:custom7,'
      'custom8=:custom8,'
      'custom9=:custom9,'
      'custom10=:custom10,'
      'posyear=:posyear,'
      'posmonth=:posmonth,'
      'tag=:tag,'
      'puraddqty=:puraddqty,'
      'mrp=:mrp,'
      'advancedays=:advancedays,'
      'traderid=:traderid,'
      'minpurqty=:minpurqty,'
      'pause=:pause,'
      'batch=:batch,'
      'custom11=:custom11,'
      'custom12=:custom12,'
      'custom13=:custom13,'
      'custom14=:custom14,'
      'custom15=:custom15,'
      'drp=:drp,'
      'empid=:empid,'
      'workshopid=:workshopid,'
      'warndays=:warndays,'
      'share=:share,'
      'imei=:imei,'
      'length=:length,'
      'width=:width,'
      'height=:height,'
      'specificweight=:specificweight,'
      'scorerate=:scorerate,'
      'scoreexch=:scoreexch,'
      'sharedraw=:sharedraw,'
      'mindrawqty=:mindrawqty'
      ' where p_id=:OLD_p_id')
    SQL.Strings = (
      'select * from v_td_product')
    AfterScroll = MainDataSetUAfterScroll
  end
end
